Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2965
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.3 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qt_invoices` and 3 other fields	High correlation
`recency_days` is highly correlated with `qt_invoices`	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_assortment`	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_assortment` is highly correlated with `assortment` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 1 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`assortment` is highly correlated with `qt_invoices`	High correlation
`avg_ticket` is highly correlated with `qt_returned` and 1 other fields	High correlation
`qt_returned` is highly correlated with `avg_ticket`	High correlation
`avg_basket_size` is highly correlated with `avg_ticket`	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 2 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `no_items`	High correlation
`gross_revenue` is highly correlated with `qt_invoices` and 3 other fields	High correlation
`qt_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`no_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`assortment` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `qt_returned` and 1 other fields	High correlation
`qt_returned` is highly correlated with `no_items` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_assortment` is highly correlated with `avg_basket_size`	High correlation
`avg_ticket` is highly skewed (γ1 = 25.14435057)	Skewed
`qt_returned` is highly skewed (γ1 = 26.83769591)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 33 (1.1%) zeros	Zeros
`qt_returned` has 1480 (49.9%) zeros	Zeros

Reproduction

Analysis started	2021-11-18 15:55:21.443632
Analysis finished	2021-11-18 15:55:55.539562
Duration	34.1 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2965
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2308.542664

Minimum	0
Maximum	5689
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.2
Q1	926
median	2113
Q3	3523
95-th percentile	5010.2
Maximum	5689
Range	5689
Interquartile range (IQR)	2597

Descriptive statistics

Standard deviation	1547.283204
Coefficient of variation (CV)	0.670242412
Kurtosis	-1.011794798
Mean	2308.542664
Median Absolute Deviation (MAD)	1265
Skewness	0.3400689729
Sum	6844829
Variance	2394085.312
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3002	1	< 0.1%
2987	1	< 0.1%
2990	1	< 0.1%
2991	1	< 0.1%
2992	1	< 0.1%
2993	1	< 0.1%
2996	1	< 0.1%
2998	1	< 0.1%
2999	1	< 0.1%
Other values (2955)	2955	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5689	1	< 0.1%
5670	1	< 0.1%
5660	1	< 0.1%
5654	1	< 0.1%
5633	1	< 0.1%
5629	1	< 0.1%
5623	1	< 0.1%
5612	1	< 0.1%
5611	1	< 0.1%
5601	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2965
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.24992

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.2
Q1	13799
median	15220
Q3	16770
95-th percentile	17964.8
Maximum	18287
Range	5940
Interquartile range (IQR)	2971

Descriptive statistics

Standard deviation	1719.522705
Coefficient of variation (CV)	0.1126060617
Kurtosis	-1.206368645
Mean	15270.24992
Median Absolute Deviation (MAD)	1489
Skewness	0.03249797116
Sum	45276291
Variance	2956758.332
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2955)	2955	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2950
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2693.612793

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	230.892
Q1	570.96
median	1084.1
Q3	2308.06
95-th percentile	7180.164
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1737.1

Descriptive statistics

Standard deviation	10118.95249
Coefficient of variation (CV)	3.756647028
Kurtosis	398.8579858
Mean	2693.612793
Median Absolute Deviation (MAD)	670.06
Skewness	17.65630412
Sum	7986561.93
Variance	102393199.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2053.02	2	0.1%
1353.74	2	0.1%
734.94	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
533.33	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
379.65	2	0.1%
745.06	2	0.1%
Other values (2940)	2945	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.21450253

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.57878668
Coefficient of variation (CV)	1.208119406
Kurtosis	2.760237102
Mean	64.21450253
Median Absolute Deviation (MAD)	26
Skewness	1.794679718
Sum	190396
Variance	6018.468143
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	84	2.8%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
16	55	1.9%
Other values (262)	2216	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.9%
4	87	2.9%
5	43	1.5%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qt_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	57
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.724451939

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.847025721
Coefficient of variation (CV)	1.545479954
Kurtosis	190.178526
Mean	5.724451939
Median Absolute Deviation (MAD)	2
Skewness	10.74593132
Sum	16973
Variance	78.26986411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	784	26.4%
3	497	16.8%
4	394	13.3%
5	236	8.0%
1	189	6.4%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%
Other values (47)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	189	6.4%
2	784	26.4%
3	497	16.8%
4	394	13.3%
5	236	8.0%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

no_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1676
Distinct (%)	56.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1583.442833

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2
5-th percentile	103
Q1	297
median	642
Q3	1401
95-th percentile	4404
Maximum	196844
Range	196842
Interquartile range (IQR)	1104

Descriptive statistics

Standard deviation	5707.571653
Coefficient of variation (CV)	3.604532815
Kurtosis	516.3654066
Mean	1583.442833
Median Absolute Deviation (MAD)	422
Skewness	18.73041713
Sum	4694908
Variance	32576374.17
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
288	8	0.3%
272	8	0.3%
260	8	0.3%
246	8	0.3%
134	8	0.3%
84	8	0.3%
219	7	0.2%
Other values (1666)	2881	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57872	1	< 0.1%
50255	1	< 0.1%

assortment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	467
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.810118

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7838
Range	7837
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.4468531
Coefficient of variation (CV)	2.19401184
Kurtosis	354.1084542
Mean	122.810118
Median Absolute Deviation (MAD)	44
Skewness	15.67328761
Sum	364132
Variance	72601.60665
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	44	1.5%
20	37	1.2%
35	35	1.2%
29	34	1.1%
15	33	1.1%
19	33	1.1%
11	32	1.1%
25	31	1.0%
26	30	1.0%
27	30	1.0%
Other values (457)	2626	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	0.2%
2	14	0.5%
3	15	0.5%
4	17	0.6%
5	26	0.9%
6	28	0.9%
7	18	0.6%
8	19	0.6%
9	26	0.9%
10	28	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5589	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2697	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1672	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1992
Distinct (%)	67.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.0066172

Minimum	2.15
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.15
5-th percentile	4.914
Q1	13.12
median	17.94
Q3	24.98
95-th percentile	90.236
Maximum	4453.43
Range	4451.28
Interquartile range (IQR)	11.86

Descriptive statistics

Standard deviation	119.5919146
Coefficient of variation (CV)	3.623270869
Kurtosis	812.1480741
Mean	33.0066172
Median Absolute Deviation (MAD)	5.97
Skewness	25.14435057
Sum	97864.62
Variance	14302.22603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.49	7	0.2%
16.82	6	0.2%
16.39	6	0.2%
16.92	6	0.2%
19.06	6	0.2%
17.66	6	0.2%
17.71	6	0.2%
19.44	5	0.2%
10	5	0.2%
17.13	5	0.2%
Other values (1982)	2907	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.15	1	< 0.1%
2.43	1	< 0.1%
2.46	1	< 0.1%
2.51	1	< 0.1%
2.52	1	< 0.1%
2.65	1	< 0.1%
2.66	1	< 0.1%
2.71	1	< 0.1%
2.76	1	< 0.1%
2.77	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.99	1	< 0.1%
872.13	1	< 0.1%
841.02	1	< 0.1%
651.17	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.33252032

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	26
median	48.28571429
Q3	85.33333333
95-th percentile	200.8
Maximum	366
Range	365
Interquartile range (IQR)	59.33333333

Descriptive statistics

Standard deviation	63.52158276
Coefficient of variation (CV)	0.943401234
Kurtosis	4.903585736
Mean	67.33252032
Median Absolute Deviation (MAD)	26.28571429
Skewness	2.065604551
Sum	199640.9227
Variance	4034.991476
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
70	21	0.7%
4	21	0.7%
7	20	0.7%
35	18	0.6%
49	18	0.6%
46	17	0.6%
11	17	0.6%
21	17	0.6%
5	16	0.5%
Other values (1248)	2775	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	21	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1347
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06318195167

Minimum	0.005449591281
Maximum	3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.009433962264
Q1	0.01777777778
median	0.0293040293
Q3	0.05539358601
95-th percentile	0.2222222222
Maximum	3
Range	2.994550409
Interquartile range (IQR)	0.03761580823

Descriptive statistics

Standard deviation	0.1344202854
Coefficient of variation (CV)	2.127510813
Kurtosis	121.9648159
Mean	0.06318195167
Median Absolute Deviation (MAD)	0.01426643532
Skewness	8.793597948
Sum	187.3344867
Variance	0.01806881312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3333333333	21	0.7%
0.1666666667	21	0.7%
0.02777777778	20	0.7%
0.09090909091	19	0.6%
0.0625	17	0.6%
0.1333333333	16	0.5%
0.03571428571	15	0.5%
0.4	15	0.5%
0.25	15	0.5%
0.02380952381	15	0.5%
Other values (1337)	2791	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
3	1	< 0.1%
2	1	< 0.1%
1.571428571	1	< 0.1%
1.5	3	0.1%
1	14	0.5%
0.8333333333	1	< 0.1%
0.75	1	< 0.1%
0.6666666667	12	0.4%
0.6487935657	1	< 0.1%
0.6	1	< 0.1%

qt_returned
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	172
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.95615514

Minimum	0
Maximum	9014
Zeros	1480
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	6
95-th percentile	61.8
Maximum	9014
Range	9014
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	228.7536437
Coefficient of variation (CV)	9.166221416
Kurtosis	911.4384425
Mean	24.95615514
Median Absolute Deviation (MAD)	1
Skewness	26.83769591
Sum	73995
Variance	52328.22952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1480	49.9%
1	295	9.9%
3	169	5.7%
6	93	3.1%
2	86	2.9%
4	71	2.4%
5	43	1.5%
12	43	1.5%
8	40	1.3%
7	38	1.3%
Other values (162)	607	20.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1480	49.9%
1	295	9.9%
2	86	2.9%
3	169	5.7%
4	71	2.4%
5	43	1.5%
6	93	3.1%
7	38	1.3%
8	40	1.3%
9	36	1.2%

Value	Count	Frequency (%)
9014	1	< 0.1%
4824	1	< 0.1%
4027	1	< 0.1%
2302	2	0.1%
1776	1	< 0.1%
1608	1	< 0.1%
1589	1	< 0.1%
1515	1	< 0.1%
1278	1	< 0.1%
1242	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1979
Distinct (%)	66.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	236.5105663

Minimum	1
Maximum	6009.333333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44.27777778
Q1	103.3
median	172.3333333
Q3	281.6923077
95-th percentile	599.76
Maximum	6009.333333
Range	6008.333333
Interquartile range (IQR)	178.3923077

Descriptive statistics

Standard deviation	284.1165832
Coefficient of variation (CV)	1.201284947
Kurtosis	102.5495958
Mean	236.5105663
Median Absolute Deviation (MAD)	83
Skewness	7.694246699
Sum	701253.8291
Variance	80722.23286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
82	9	0.3%
73	9	0.3%
86	9	0.3%
60	8	0.3%
140	8	0.3%
163	8	0.3%
136	8	0.3%
75	8	0.3%
Other values (1969)	2877	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%

avg_assortment
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	910
Distinct (%)	30.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.50105306

Minimum	0.2
Maximum	259
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.709677419
median	13.6
Q3	22
95-th percentile	46
Maximum	259
Range	258.8
Interquartile range (IQR)	14.29032258

Descriptive statistics

Standard deviation	15.46481281
Coefficient of variation (CV)	0.883650416
Kurtosis	29.30907341
Mean	17.50105306
Median Absolute Deviation (MAD)	6.6
Skewness	3.436201515
Sum	51890.62232
Variance	239.1604354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	43	1.5%
9	42	1.4%
8	39	1.3%
16	39	1.3%
14	38	1.3%
17	38	1.3%
7	37	1.2%
5	36	1.2%
11	36	1.2%
15	34	1.1%
Other values (900)	2583	87.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
259	1	< 0.1%
177	1	< 0.1%
148	1	< 0.1%
127	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
101	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qt_invoices	no_items	assortment	avg_ticket	avg_recency_days	frequency	qt_returned	avg_basket_size	avg_assortment
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	18.15	35.500000	0.486111	21.0	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	18.90	27.250000	0.048780	6.0	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	28.90	23.187500	0.045699	50.0	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	439.0	28.0	33.87	92.666667	0.017921	0.0	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	80.0	3.0	292.00	8.600000	0.136364	22.0	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	45.33	23.200000	0.054441	27.0	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	17.22	18.300000	0.073569	281.0	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	88.72	35.700000	0.039106	41.0	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.54	4.144444	0.315508	231.0	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	613.0	67.0	29.93	47.666667	0.024390	0.0	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qt_invoices	no_items	assortment	avg_ticket	avg_recency_days	frequency	qt_returned	avg_basket_size	avg_assortment
2955	5601	17727	1060.25	15.0	1.0	645.0	66.0	16.06	6.0	0.285714	6.0	645.000000	66.000000
2956	5611	17232	421.52	2.0	2.0	203.0	36.0	11.71	12.0	0.153846	0.0	101.500000	15.000000
2957	5612	17468	137.00	10.0	2.0	116.0	5.0	27.40	4.0	0.400000	0.0	58.000000	2.500000
2958	5623	13596	697.04	5.0	2.0	406.0	166.0	4.20	7.0	0.250000	0.0	203.000000	66.500000
2959	5629	14893	1237.85	9.0	2.0	799.0	73.0	16.96	2.0	0.666667	0.0	399.500000	36.000000
2960	5633	12479	473.20	11.0	1.0	382.0	30.0	15.77	4.0	0.333333	34.0	382.000000	30.000000
2961	5654	14126	706.13	7.0	3.0	508.0	15.0	47.08	3.0	1.000000	50.0	169.333333	4.666667
2962	5660	13521	1092.39	1.0	3.0	733.0	435.0	2.51	4.5	0.300000	0.0	244.333333	104.000000
2963	5670	15060	301.84	8.0	4.0	262.0	120.0	2.52	1.0	2.000000	0.0	65.500000	20.000000
2964	5689	12558	269.96	7.0	1.0	196.0	11.0	24.54	6.0	0.285714	102.0	196.000000	11.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows